Appendix C: Calculations (Allocation Methods)

Certain solutions contain additional Value Types for expressions that are focused on these particular use cases:

Data Caching Examples (For example, People Planning)

  • After Plan Data rows are added during Calculate Plan Data, this data can also be added to an in-memory Cache that's available during processing for later querying via sample Allocation Methods which call a XFBR String to pass over this data and return results that were added, min, max, added across periods, return number of days between Code1 & Code2 (for example), etc. In sample Allocation Methods provided with solutions such as People Planning, refer to Custom Functions (XFBR) and its equivalent Calculation Plan for several examples. More than likely the returned value will be an input into another function.

  • Designed for when you have multiple Registers across multiple Instances of same Register item (e.g. Employee). Keeps an individual cache for each Register item across Instances. Designers will want these to be the highest Sequence in the Execution Plan. Order matters. These cross-Register Calculation Plans need to run late in the Execution Plan. An example is FICA (Social Security tax calculation) is one of the reasons but multiple instances of the same Register item makes this necessary. For example, caching would calculate all Salary Expense first and then apply a FICA calculation later in the Sequence for the Execution Plan. This is for calculations that cross Register Instances.

  • There are Single Register Instance calculation reasons to use these caching examples. Caching could occur for a single Register Instance by using a later Sequence within a single Allocation Method. Example is adding up records from multiple Allocation Plan details within one Allocation Plan. Again, order matters.

  • Think of these examples provided as Excel Sum/Min/Max etc. as a sample formula that can be copied, pasted and modified to the user's liking to fit their use case. Examples:

    • Timespan Day: Number of days between date fields.

    • Sum Account Period: adds up an account value over a single period.

    • Sum Account Period Cumulative: adds across previous periods, etc.

    • Sum Account Custom: pass it criteria from any field in the Plan Data (also in the cache).

    • More advanced example is GetLimitResidual (FICA example). This one is different since you pass in RegisterID, Account, Period, Field to Sum (or other math) on (such as Amount, NCode5, etc.). Any math performed must be on a numeric field in Plan Data. Note that this will not work against text-based Code1-12 since those are stored in Plan Data (and resulting Cache) but would work against fields like Amount, NCode1-8 and any other that is inherently stored as a decimal value.

Capital Planning

  • (1DB)Declining Balance: Depreciation-calculation system that involves applying the depreciation rate against the non-depreciated balance. Instead of spreading the cost of the asset evenly over its life, this system expenses the asset at a constant rate, which results in declining depreciation charges each successive period.

    • The declining balance formula is:  1 × Straight-line depreciation rate × Book value at the beginning of the year.

  • (1.5DB) Declining Balance: Accelerated form of depreciation under which the vast majority of the depreciation associated with a fixed asset is recognized during the first few years of its useful life.

    • The 1.5 declining balance formula is:  1.5 × Straight-line depreciation rate × Book value at the beginning of the year.

  • (2DB)Declining Balance: Accelerated form of depreciation under which the vast majority of the depreciation associated with a fixed asset is recognized during the first few years of its useful life.

    • The double declining balance formula is:  2 × Straight-line depreciation rate × Book value at the beginning of the year.

  • (SL)Straight Line: Straight line depreciation method charges cost evenly throughout the useful life of a fixed asset.

    • The Straight Line formula is: (Cost − Residual Value) x Rate of depreciation.

  • (SYD)Sum Years Digits: Sum of the years' digits method of depreciation is one of the accelerated depreciation techniques which are based on the assumption that assets are generally more productive when they are new, and their productivity decreases as they become old.

    • The Sum of Years Digits formula is: (Cost − Residual Value) x (Remaining Useful Life / Sum of Years Digits)

Cash Planning

    • Interest Daily

    • Interest Monthly

    • Interest Annual

    • Cash Term Impact